Oracle Database: PL/SQL Fundamentals

Beschreibung

This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL. It helps you understand the benefits of this powerful programming language, while teaching you real-world scenarios where these lessons can be applied.

Learn To:

  • Describe the features and syntax of PL/SQL.
  • Design a PL/SQL anonymous block that executes efficiently.
  • Write PL/SQL code to interface with the database.
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors
  • Handle runtime errors.
  • Describe stored procedures and functions.
  • Apply declaring identifiers and trapping exceptions.
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Gain Experience through Hands-On Practice

In this course, you’ll learn from expert Oracle instructors, then engage in demonstrations and hands-on practice to reinforce the fundamental concepts. You’ll use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

Teilnehmerkreis

Teilnehmerkreis

  • Systemanalytiker
  • PL/SQL-Entwickler
  • Technischer Berater
  • Formsentwickler

Vorkenntnisse

Empfehlenswerte verwandte Kurse:

  • Using Java - for PL/SQL and Database Developers

This Java for PL/SQL and Developers training teaches you to access Oracle Database using JDBC , UCP, Java stored procedures and SQLJ technologies. Learn to create, load, resolve and publish Java classes in the Database and more.

  • Oracle Database: Develop PL/SQL Program Units

This Oracle Database: Develop PL/SQL Program Units training helps you enhance your skills by developing stored procedures, functions, packages, and database triggers. Learn to manage PL/SQL program units and use Oracle-supplied packages.

Kursziele

Kursziele

  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous block that execute efficiently
  • Write PL/SQL code to interface with the database
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Handle runtime errors
  • Create and execute simple stored procedures and functions

Kursthemen

Introduction

  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Using SQL Statements within a PL/SQL Block
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Creating Stored Procedures and Functions

Kursdetails

Startdatum 14.04.2020 - 09:00
Enddatum 16.04.2020 - 17:00
Anmeldungsende 07.04.2020 - 09:00
Netto Einzelpreis € 1.422,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Database: PL/SQL Fundamentals
Ort München
Abgeschlossen